package top.timous.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import top.timous.pojo.ProvinceInfo;

import java.util.List;

@Mapper
public interface ProvinceMapper {

    @Select("SELECT * FROM provinces WHERE  province_id NOT IN ( SELECT province_id FROM epidemics WHERE data_year=#{year} AND data_month=#{month} AND data_day=#{day} ) order by province_id LIMIT 6")
    public List<ProvinceInfo> noDataProvinceList(@Param("year") int year , @Param("month") int month , @Param("day") int day);

}
